Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

ryc_ri_default table — rycri

This table defines the default referential integrity (RI) rules to apply when manually maintaining relationships in the ryc_relationship table.

Table 4–31 lists the table’s FLA, fields, and foreign keys.

Table 4–31: ryc_ri_default table information 

Table FLA	Fields (data type)	Foreign keys
rycri	ri_default_obj (Decimal) relationship_type (Character) action_type (Character) default_rule (Character)	None

Table 4–32 gives details of the table’s indexes.

Table 4–32: ryc_ri_default index information 

Index name	Elements	Type
XPKryc_ri_default	ri_default_obj	Primary Unique
XAK1ryc_ri_default	relationship_type action_type	Unique
XIE1ryc_ri_default	action_type	Nonunique

The rules in this table are used to default the parent and child actions based on the value of the identifying_relationship and nulls_allowed fields.

The standard set of referential integrity defaults used by Progress Dynamics are as follows:

For identifying and nonidentifying but with no nulls allowed, the defaults are:
Child Delete — None
Child Insert — Restrict
Child Update — Restrict
Parent Delete — Restrict
Parent Insert — None
Parent Update — Restrict
For nonidentifying but with nulls allowed, the defaults are:
Child Delete — None
Child Insert — Set Null
Child Update — Set Null
Parent Delete — Set Null
Parent Insert — None
Parent Update — Set Null

These are usually correct apart from the need to sometimes change the delete rules for the parent to cascade. Sometimes even when a relationship allows nulls, you still want a restrict rule rather than a set null rule.